Filename: invoices.csv
An invoice is a record of a bill for a customer, and how much (if any) has been paid. The invoice can be fully paid, partially paid or completely unpaid. Any unpaid amount will attempt to be collected by the billing system. If the user is using “Credit Card” as their statement method their card will be auto-billed for the outstanding amount, all other statement methods will have a notice sent about the outstanding amount and any de-activation steps will be taken if the amount is past due.
Credits to the account are represented as a negative invoice with zero dollars paid.
This has the following columns:
| Column Name | Description |
|---|---|
| invoice_number | unique number to indentify the invoice on the external billing system |
| customer_original_id | the unique id for the matching record in the customer file. Multiple entries for the same customer are accepted and all will be added. |
| total | the total amount owed for this invoice |
| invoice_date | the date the invoice was created in format MM/DD/YYYY |
| paid | the amount of the total that has been paid for this invoice. If the invoice is closed/paid then this should be the same as the total |
| start_date | the start time period for the service period that this invoice covers MM/DD/YYYY. This can be the same as the invoice_date |
| end_date | the end time period for the service period that this invoice covers MM/DD/YYYY. This can be the same as the invoice_date |
| short_description | a short description (under 250 characters) for what the invoice is for |